CREATE VIEW [dbo].[View_GetOrderDetail]
AS
SELECT     dbo.MRP_OrderDetail.IsComplete, dbo.MRP_Order.OrderCode, dbo.MRP_Order.CustomerID, dbo.MRP_OrderDetail.Quantity, 
                      dbo.MRP_OrderDetail.ProductID, dbo.MRP_OrderDetail.SignedOffQty, dbo.MRP_OrderDetail.SendedQty, dbo.MRP_OrderDetail.RequiredDate, 
                      dbo.MRP_OrderDetail.ID, dbo.MRP_OrderDetail.StockedQty
FROM         dbo.MRP_Order INNER JOIN
                      dbo.MRP_OrderDetail ON dbo.MRP_Order.ID = dbo.MRP_OrderDetail.OrderID

GO